
/**
 * Module dependencies.
 */

var express = require('express');
var routes = require('./routes');
var user = require('./routes/user');
var http = require('http');
var path = require('path');
var engine = require('ejs-locals');
var mysql	= require('mysql');

var DBpool = mysql.createPool({
	// host : '172.16.3.111',
	host : '172.16.1.163',
	user : 'gamevil',
	password : 'vlwlrpaqlf',
	database : 'pz_user'
});

var app = express();

// all environments
app.set('DBPool', DBpool);
app.set('port', process.env.PORT || 53000);
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'ejs');
app.use(express.favicon());
app.use(express.logger('dev'));
app.use(express.json());
app.use(express.urlencoded());
app.use(express.methodOverride());
app.use(app.router);
app.use(express.static(path.join(__dirname, 'public')));
app.engine('ejs', engine);


// development only
if ('development' == app.get('env')) {
  app.use(express.errorHandler());
}

app.get('/', routes.index);
// app.get('/users', user.list);
app.get('/users/:type&:value', user.lookup_user_info);

http.createServer(app).listen(app.get('port'), function(){
  console.log('Express server listening on port ' + app.get('port'));
});
